COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2021-03-11T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note', 'ingressi_terapia_intensiva', 'note_test', 'note_casi', 'totale_positivi_test_molecolare', 'totale_positivi_test_antigenico_rapido', 'tamponi_test_molecolare', 'tamponi_test_antigenico_rapido', 'codice_nuts_1', 'codice_nuts_2']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... note ingressi_terapia_intensiva note_test note_casi totale_positivi_test_molecolare totale_positivi_test_antigenico_rapido tamponi_test_molecolare tamponi_test_antigenico_rapido codice_nuts_1 codice_nuts_2
8017 2021-03-11T17:00:00 ITA 19 Sicilia 38.115697 13.362357 671 100 771 12751 ... NaN 3.0 NaN NaN 158865.0 0.0 1832727.0 868928.0 ITG ITG1
8018 2021-03-11T17:00:00 ITA 9 Toscana 43.769231 11.255889 1280 208 1488 21409 ... NaN 14.0 NaN NaN 168010.0 1037.0 2623187.0 351213.0 ITI ITI1
8019 2021-03-11T17:00:00 ITA 10 Umbria 43.106758 12.388247 407 80 487 6110 ... Si fa presente che 9 dei ricoveri NON UTI, non... 5.0 NaN NaN 47292.0 0.0 730548.0 145857.0 ITI ITI2
8020 2021-03-11T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 12 2 14 216 ... NaN 0.0 NaN NaN 8212.0 0.0 76641.0 5449.0 ITC ITC2
8021 2021-03-11T17:00:00 ITA 5 Veneto 45.434905 12.338452 1073 154 1227 30447 ... Nei valori riportati per le terapie intensive ... 19.0 NaN NaN 341780.0 6333.0 4190947.0 1232282.0 ITH ITH3

5 rows × 30 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives ... ingr_ter_intens note_test note_casi totale_positivi_test_molecolare totale_positivi_test_antigenico_rapido tamponi_test_molecolare tamponi_test_antigenico_rapido codice_nuts_1 codice_nuts_2 Pop
Date
2021-03-07 2021-03-07 Veneto 45.434905 12.338452 917 132 1049 28019 29068 776 ... 10.0 NaN NaN 337301.0 5209.0 4136572.0 1146831.0 ITH ITH3 4879133
2021-03-08 2021-03-08 Veneto 45.434905 12.338452 950 137 1087 28427 29514 446 ... 8.0 NaN NaN 337770.0 5497.0 4142229.0 1151434.0 ITH ITH3 4879133
2021-03-09 2021-03-09 Veneto 45.434905 12.338452 1013 141 1154 29056 30210 696 ... 29.0 NaN NaN 339378.0 5497.0 4157977.0 1178965.0 ITH ITH3 4879133
2021-03-10 2021-03-10 Veneto 45.434905 12.338452 1061 148 1209 29579 30788 578 ... 19.0 NaN NaN 340939.0 5497.0 4174215.0 1206020.0 ITH ITH3 4879133
2021-03-11 2021-03-11 Veneto 45.434905 12.338452 1073 154 1227 30447 31674 886 ... 19.0 NaN NaN 341780.0 6333.0 4190947.0 1232282.0 ITH ITH3 4879133

5 rows × 29 columns

 

daily numbers & moving averages (MA)

(Tip: double click and click on legend to select one or multiple regions in graphs)

 

All regions together

Molecular test positive rate

Antigene test positive rate